package com.zfy.cmsservice.mapper;

import com.zfy.cmsservice.entity.ExamScores;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.zfy.cmsservice.entity.result.ScoreStatistic;
import com.zfy.cmsservice.entity.vo.ExamScoreVo;
import com.zfy.cmsservice.entity.vo.ScoresVo;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * <p>
 * 考试成绩表 Mapper 接口
 * </p>
 *
 * @author testjava
 * @since 2023-12-10
 */
public interface ExamScoresMapper extends BaseMapper<ExamScores> {

    List<ScoresVo> pageExamScores(@Param("page") long page, @Param("size") long size, @Param("begin") Integer begin, @Param("end") Integer end);

    int pageExamScoresTotal(@Param("page") long page, @Param("size") long size, @Param("begin") Integer begin, @Param("end") Integer end);


    List<ExamScoreVo> getExamScores(@Param("idNumber") String idNumber, @Param("semesterId") String semesterId);

    List<ScoreStatistic> getScoreStatistics();

    List<ExamScores> findByStudentId(@Param("id") String id);
}
